# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月19日
"""
import openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx')
mySheet=myBook.active

myRange=mySheet.iter_cols(min_row=5,min_col=2)
myMax=['最大值']
myMax+=[max([myCell.value for myCell in myCol]) for myCol in myRange]
mySheet.append(myMax)
myBook.save('收入表.xlsx')